<?php
require_once('../Connections/mlu.php'); 
  $o=$_GET['o'];
  $query="select *, round(depositati.prezzo/2,2) as prezzo_reale
from depositati
join carrelli using (idmlu)
join libri using (idlibro)
join clienti on ID=idcliente
where idordine=$o";
  $view = mysql_query($query, $mlu) or die(mysql_error());
  ?>
  <table border="1" width="100%">
  <?php
  $i=0;
  ?>
  <table width="100%" border="1">
  <tr>
  <td> Idmlu </td>
  <td>Titolo </td>
  <td>Prezzo Meeting </td>
  <td>Cognome</td>
  <td>Nome </td>
  </tr>
  <?php
  	while ($row= mysql_fetch_assoc($view))
	{	?>
		<tr>
        <td width="10%"><?php echo $row['IdMLU']; ?></td>
		<td width="30%"><?php echo $row['titolo']; ?></td>
	    <td width="5%"><?php echo $row['prezzo_reale']; ?></td>
        <td width="30%"><?php echo $row['Cognome']; ?> </td>
        <td width="30%"><?php echo $row['Nome'];	?></td>
		</tr>
<?php	}
?>
</table>